File code/Jtm.php
class Tlf\Jtm
Json To Mysql class
See source code at /code/Jtm.php
Constants
Properties
-
public bool $disable_foreign_key_checks = false;
Settrue
to disable foreign key checks during INSERTs
Methods
-
public function json_line_to_array(string $line): array
Convert a json line into an array -
public function is_date($value): bool
check if a value is a date -
public function clean_schema(array $dirty_schema): array
convert column names to camel_case -
public function execute_insert_files(string $prefix, \PDO $pdo): int
-
public function generate_schema(string $source_file, array $schema_info): array
-
public function generate_schema_info($source_file)
-
public function generate_sql_create(string $tableName, array $schema, bool $dropIfExists=true)
-
public function generate_sql_insert(string $source_file, string $out_prefix, string $tableName, array $schema, $chunkByLength, callable $rowModifier = null)
Generate sql for INSERTs and write it to disk